How do I repair damaged MySQL databases?

Situation:

You need to repair a damaged MySQL database, or check the integrity of the database.

Solution:

Due to variety of reasons including damaged hard drive sectors or lack of hard drive space, the MySQL databases can be damaged. To repair, follow the steps below:

1. WebTrends services need to be stopped and started in the correct order to ensure that proper connectivity between modules in the application. Please use the order below to help prevent any possible issues.

Order to stop the services in
"WebTrends - User Interface"
"WebTrends - Report Cache Server"
"WebTrends - Express Data Mover"
"WebTrends - Express Analysis Engine"
"WebTrends - GeoTrends"
"WebTrends - System Monitor"
"WebTrends - Scheduler Agent"

2. Open a DOS prompt.

3. Navigate to the following WebTrends directory:
/common/database/mysql/bin/

4. Run the following commands:
mysqlcheck.exe -r --databases wt_sched -u Administrator -p
mysqlcheck.exe -r --databases wtmaster -u Administrator -p

Note: Use the user name and password that was created during the MySQL portion of the WebTrends product installation.

5. When prompted for the password, enter the appropriate password used for the MySQL installation.

6. Restart the WebTrends Services in the following order:

• "WebTrends - MySQL"
• "WebTrends - Scheduler Agent"
• "WebTrends - System Monitor"
• "WebTrends - GeoTrends"
• "WebTrends - Express Analysis Engine"
• "WebTrends - Express Data Mover"
• "WebTrends - Report Cache Server"
• "WebTrends - User Interface"

Additional Information

To get all command options for mysqlcheck.exe, type mysqlcheck at the command prompt in the directory specified in Step 2 of the repair steps.